package com.sss.otep.orm.model;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Embedded;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.annotations.SQLDelete;
/**
 * 
 * @author PraditR
 *
 */
@Entity
@Table(name="CPK_WS_MEMCPK")

@javax.persistence.SequenceGenerator(
	    name="member_seq",
	    sequenceName="SEQ_CPK_WS_MEMCPK",	    
	    initialValue=0
)

/**
 * CUSTOME DELETE STATEMENT
 */
@SQLDelete( sql= "UPDATE CPK_WS_MEMCPK SET RECORD_STATUS = 'D' WHERE CPK_ID = ?")
public class Member implements Serializable {

	/**
	 * 
	 */
	private static final long serialVersionUID = -1069226308410847455L;
	@Id @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="member_seq") 
	@Column(name="CPK_ID")
	private Integer cpkId;
	
	@Column(name="CPK_TYPE")
	private String cpkType;
	
	@Column(name="CPK_MEM_IDCARD")
	private String cpkMemIdcard;
	
	@Column(name="CPK_MEM_NAME")
	private String cpkMemName;
	
	@Column(name="CPK_MEM_SURNAME")
	private String cpkMemSurname;
	
	@Column(name="CPK_MEM_STATUS")
	private String cpkMemStatus;
	
	@Column(name="CPK_MEM_PROVINCE")
	private String cpkMemProvince;
	
	@Column(name="CPK_MEM_AMPHUR")
	private String cpkMemAmphur;
	
	@Column(name="CPK_MEM_ORGNAME")
	private String cpkMemOrgname;
	
	@Column(name="CPK_MEM_DEPARTMENT")
	private String cpkMemDepartment;
	
	@Embedded private RecordInfo recordInfo;
	
	public Integer getCpkId() {
		return cpkId;
	}
	public void setCpkId(Integer cpkId) {
		this.cpkId = cpkId;
	}
	public String getCpkType() {
		return cpkType;
	}
	public void setCpkType(String cpkType) {
		this.cpkType = cpkType;
	}
	public String getCpkMemIdcard() {
		return cpkMemIdcard;
	}
	public void setCpkMemIdcard(String cpkMemIdcard) {
		this.cpkMemIdcard = cpkMemIdcard;
	}
	public String getCpkMemName() {
		return cpkMemName;
	}
	public void setCpkMemName(String cpkMemName) {
		this.cpkMemName = cpkMemName;
	}
	public String getCpkMemSurname() {
		return cpkMemSurname;
	}
	public void setCpkMemSurname(String cpkMemSurname) {
		this.cpkMemSurname = cpkMemSurname;
	}
	public String getCpkMemStatus() {
		return cpkMemStatus;
	}
	public void setCpkMemStatus(String cpkMemStatus) {
		this.cpkMemStatus = cpkMemStatus;
	}
	public String getCpkMemProvince() {
		return cpkMemProvince;
	}
	public void setCpkMemProvince(String cpkMemProvince) {
		this.cpkMemProvince = cpkMemProvince;
	}
	public String getCpkMemAmphur() {
		return cpkMemAmphur;
	}
	public void setCpkMemAmphur(String cpkMemAmphur) {
		this.cpkMemAmphur = cpkMemAmphur;
	}
	public String getCpkMemOrgname() {
		return cpkMemOrgname;
	}
	public void setCpkMemOrgname(String cpkMemOrgname) {
		this.cpkMemOrgname = cpkMemOrgname;
	}
	public String getCpkMemDepartment() {
		return cpkMemDepartment;
	}
	public void setCpkMemDepartment(String cpkMemDepartment) {
		this.cpkMemDepartment = cpkMemDepartment;
	}
	public void setRecordInfo(RecordInfo recordInfo) {
		this.recordInfo = recordInfo;
	}
	public RecordInfo getRecordInfo() {
		return recordInfo;
	}
}
